Self-Checks In Spreadsheets: A Survey Of Current Practice
نویسنده
چکیده
A common application of spreadsheets is the development of models that deliver projections of the future financial statements of companies established to pursue ventures that are subject to project financing. A survey of 11 such spreadsheets prepared by a range of organisations shows that the amount of self-testing included in such models ranges between one formula of testing for each three formulae of calculation, down to essentially no self-testing at all.
منابع مشابه
Checks and Controls in Spreadsheets
Spreadsheets that are informally created are harder to test than they should be. Simple cross-foot checks or being easily readable are modest but attainable goals for every spreadsheet developer. This paper lists some tips on building self-checking into a spreadsheet in order to provide more confidence to the reader that a spreadsheet is robust.
متن کاملResearch Strategy and Scoping Survey on Spreadsheet Practices
We propose a research strategy for creating and deploying prescriptive recommendations for spreadsheet practice. Empirical data on usage can be used to create a taxonomy of spreadsheet classes. Within each class, existing practices and ideal practices can he combined into proposed best practices for deployment. As a first step we propose a scoping survey to gather non-anecdotal data on spreadsh...
متن کاملControls over Spreadsheets for Financial Reporting in Practice
Past studies show that only a small percent of organizations implement and enforce formal rules or informal guidelines for the designing, testing, documenting, using, modifying, sharing and archiving of spreadsheet models. Due to lack of such policies, there has been little research on how companies can effectively govern spreadsheets throughout their life cycle. This paper describes a survey i...
متن کاملEffect of education on practice and knowledge rate of hospitalized heart failure patients regarding their self-care behaviors and methods
Heart failure is one of the chronic conditions of heart in the elderly people. The current study aimed to determine the effects of education on knowledge and practice of hospitalized heart failure patients regarding their self-care behaviors. This was a quasi-experimental study with control group which was conducted on 140 patients hospitalizing in Zahedan. The primary information was gathered ...
متن کاملVisual Checking of Spreadsheets
The difference between surface and deep structures of a spreadsheet is a major cause of difficulty in checking spreadsheets. After a brief survey of current methods of checking (or debugging) spreadsheets, new visual methods of showing the deep structures are presented. Illustrations are given on how these visual methods can be employed in various interactive local and global debugging strategies.
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- CoRR
دوره abs/1001.4107 شماره
صفحات -
تاریخ انتشار 2010